package com.sky.mapper.admin;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;


import java.util.Map;

@Mapper
@Repository("adminReportMapper")
public interface ReportMapper {

    @Select("select count(*) from user where  create_time between #{begin} and #{end}")
    String newUserList(Map map);

    @Select("select sum(amount) from orders where order_time between #{begin} and #{end} and status = #{status}")
    String turnover(Map map);
}
